package com.tyteam.apps.dao;

import com.tyteam.apps.model.Tips;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;


/**
 * <p>
  * 任务注释表 Mapper 接口
 * </p>
 *
 * @author liuyu
 * @since 2018-03-20
 */
public interface TipsDao extends JpaRepository<Tips, Integer>{
	
	public Tips findByProcInsId(String procInsId);
	@Query(value = "select * from tips where t_name like concat('%',:tName,'%')",nativeQuery=true)
	public Tips getTName(@Param("tName")String tName);
	
}